• Home
• News
• Contact
• About

 Hello world My first PHP page



css


BEST WE WANT
Best Useful Information
Skip to content
Home
 
Best One
 
Career
 
Computer Coding
 
How To
 
Money
 
Technology
 
Contact

Comment box Script in php with Reply and approve by admin
Code Technique No comments
For own developing website designers looking for comments display option in every page. In this article add PHP code for comment box script in PHP with Reply option and approve by admin. Every comment submitted by user, it will hole and need approve by admin, even reply comment also. Normally most of websites have auto approve comment code, or script in the form of jQuery, Ajax it will complex.

The Comment box generated in php language, no need jquery, Ajax. This simple comment box with reply answer in php  and comment approve by admin features supported ,following code. Basically If you use of jQuery and AJAX , code very complex for use and working. Every comment must approve or moderate by admin only.


Each comment also support Reply answer either admin or user. In some other website contains comment box  with Reply answer there. But that comment auto submit to page, no moderating or delete or edit option. In this article we clear explain as simple comment box in php with Reply answer and comment approve by admin.

Features of Simple Comment Box with Reply Answer
Simple php code uses, no need of jQuery and AJAX code
Each comment uniquely identified by url  i.e  each page can maintain separate comments
All comments and Reply comments must be approve or moderate by admin only
User comments accept or delete or edit comment options available.
One MySql table suitable for all works (Comments and Reply comments)
One php code for comments display, One for creating comments.
Auto focus available for Auto Reply comments.
Comment box Script in php with Reply and approve by admin
Comment box Script in php with Reply and approve by admin


Steps to Creating Comment Box with reply
Creating table (  tbl_comment.sql )
Comment box html code include Insert query ( commentbox.php )
Comments display php code with beautiful model css code inline tag ( commentlist.php )
Admin accept , reject , delete  Comments menu option php code ( permissions.php )
How to use, any page inserting example ( index.php )
Use database setting file ( dbsetting.php )
Use image as comment avatar. To download Click Here
Creating table (  tbl_comment.sql )
The following code as sql create table

CREATE TABLE `tbl_comment` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT NULL,
  `comment` varchar(200) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  'current_url' varchar(200) NOT NULL,
  'moderate' int(2) NOT NULL 0,
  'reply' int(2) NOT NULL 0,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `tbl_comment`
  ADD PRIMARY KEY (`cid`);

In the above sql table, Where

cid --- comment id, is used to uniquely identified
pid --- parent id , is used to Reply Comment purpose , this comment row display under the main comment
comment --- actual comment as maximum 200 character length
name --- comment author name
email --- author email
date --- Current date and time
current_url --- display comment only that particular page only
moderate --- gives either 0 or 1
0 -- No moderate or comment not approve by admin
1 -- moderated or comment approved by admin
reply --- gives either 0 or 1
0 -- It is main comment , no reply comments
1 -- It is also main comment, but have some reply comments under of this
Comment box html code include Insert query ( commentbox.php )
The following php code for creating comment asking box and Mysql Insert query within


".mysql_error()."
";
}
if($s)
{
$sql="UPDATE tbl_comment SET reply = 1 WHERE cid = ".$_POST['rrpid'].";";
if(executeQuery($sql))
{
$rs=1;
}

}
}
?>


Please Fill the following form";
}

?>







Your name  *




';
}
?>



Your email  *


Website :


Your message  *








<script>
  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
  })(window,document,'script','//www.google-analytics.com/analytics.js','ga');

  ga('create', 'UA-52170159-2', 'auto');
  ga('send', 'pageview');

</script>
<script type='text/javascript'>document.write(unescape('%3Cscript src=%27http://s10.histats.com/js15.js%27 type=%27text/javascript%27%3E%3C/script%3E'));</script><a href='http://www.histats.com' target='_blank' title='website statistics' ><script  type='text/javascript' >try {Histats.start(1,1408941,4,0,0,0,'00000000');Histats.track_hits();} catch(err){};</script></a><noscript><a href='http://www.histats.com' target='_blank'><img  src='http://sstatic1.histats.com/0.gif?1408941&101' alt='website statistics' border='0'></a></noscript>